﻿using System;
using System.Collections.Generic;
using System.Text;

namespace RuleCode.Common
{
    public abstract class SqlLanguage
    {
        #region 静态字段
        public static string UPDATE = " UPDATE ";
        public static string DELETE = " DELETE ";
        public static string INSERT = " INSERT ";
        public static string SELECT = " SELECT ";
        public static string CREATE = " CREATE ";
        public static string FROM = " FROM ";
        public static string WHERE = " WHERE ";

        public static string INTO = "INTO ";
        public static string VALUES = " VALUES";
        public static string GROUP = " GROUP ";
        public static string BY = " BY ";
        public static string OREDER = " ORDER ";
        public static string SET = "SET ";

        public static string EQUAL = " = ";
        public static string LITTLEQUAL = " <= ";
        public static string LARGEEQUAL = " >= ";
        public static string NOTEQUAL = " <> ";
        public static string LARGER = " > ";
        public static string LITTLER = " < ";

        public static string YINGHAO = "'";
        public static string AT = "@";
        public static string SPACE = "  ";
        public static string LEFTBRAKET = "(";
        public static string RIGHTBRAKET = ") ";
        public static string ANYCODE = "_";
        public static string ANYSTRING = "%";
        public static string COMMOS = ",";
        public static string DOT = ".";

        public static string AVG = "AVG";
        public static string COUNT = "COUNT";
        public static string MAX = "MAX";
        public static string MIN = "MIN";
        public static string SUM = "SUM";
        public static string DESC = " DESC ";//缺一个升序
        public static string ASC = " ASC ";
        public static string DISTINCT = " DISTINCT ";

        public static string IN = " IN ";
        public static string NOTIN = " NOT IN ";
        public static string LIKE = " LIKE ";
        public static string ISNULL = " IS NULL ";
        public static string ISNOTNULL = " IS NOT NULL ";
        public static string AND = " AND ";
        public static string OR = " OR ";
        public static string NOT = " NOT ";


        public static string INDEX = " Index ";
        public static string UNIQUE =" Unique ";
        public static string CLUSTERED = " Clustered ";
        public static string NONCLUSTERED = " NonClustered ";
        public static string ON = " On ";
        public static string WITH = " WITH ";
        public static string EXISTING = " EXISTING ";
        public static string DROP = " DROP ";
        
        #endregion

    }
}
